home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
AppleScript - The Beta Release
/
AppleScript - The Beta Release.iso
/
Developer Scripts
/
FileMaker Pro 2.0 AS Examples
/
Match Data Demo
/
MatchRecords
next >
Wrap
Text File
|
1992-11-25
|
1KB
|
24 lines
tell application "FileMaker Pro"
Show every Record of window "Original"
Show Layout "Full Page" of window "Original"
copy (Record count in window "Old File") to RecordsOldFile
copy (Record count in window "Original") to RecordsOriginal
repeat with i from 1 to RecordsOldFile
copy Cell "first Name" of Record i of window "old File" to firstName
copy Cell "surname" of Record i of window "old File" to surname
repeat with j from 1 to RecordsOriginal
copy Cell "first Name" of Record j of window "Original" to orgFirstName
copy Cell "surname" of Record j of window "Original" to orgSurname
copy Cell "Match" to matches
if firstName = orgFirstName and surname = orgSurname then
Set Data Cell "match" of Record j of window "Original" to "Exists"
copy RecordsOldFile to i
end if
end repeat
Show (every Record of window "original" whose Cell "match" = "Exists")
Do Menu Menu Item "Find Omitted" of Menu "Select"
copy (Record count in window "Original") to RecordsOriginal
end repeat
Show Layout "Listing" of window "Original"
Show (every Record of window "original" whose Cell "match" = "Exists")
end tell